Profiling Report

Dataset statistics

Number of variables	16
Number of observations	5810
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.1 MiB
Average record size in memory	198.1 B

Variable types

Text	1
Numeric	14
Categorical	1

Alerts

`danceability` is highly overall correlated with `valence`	High correlation
`energy` is highly overall correlated with `loudness` and 1 other fields	High correlation
`valence` is highly overall correlated with `danceability`	High correlation
`loudness` is highly overall correlated with `energy` and 2 other fields	High correlation
`acousticness` is highly overall correlated with `energy` and 1 other fields	High correlation
`popularity` is highly overall correlated with `loudness`	High correlation
`artist_name` has unique values	Unique
`artist_id` has unique values	Unique
`key` has 663 (11.4%) zeros	Zeros
`instrumentalness` has 479 (8.2%) zeros	Zeros

Reproduction

Analysis started	2023-11-17 00:58:01.242808
Analysis finished	2023-11-17 00:58:32.721633
Duration	31.48 seconds
Software version	ydata-profiling vv4.6.0
Download configuration	config.json

artist_name
Text

UNIQUE

Distinct	5810
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	443.3 KiB

Length

Max length	46
Median length	37
Mean length	12.15611
Min length	1

Characters and Unicode

Total characters	70627
Distinct characters	101
Distinct categories	17 ?
Distinct scripts	2 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5810 ?
Unique (%)	100.0%

Sample

1st row	Frank Sinatra
2nd row	Vladimir Horowitz
3rd row	Johnny Cash
4th row	Billie Holiday
5th row	Bob Dylan

Value	Count	Frequency (%)
the	710	6.0%
	136	1.1%
of	67	0.6%
john	61	0.5%
band	42	0.4%
johnny	37	0.3%
joe	36	0.3%
paul	35	0.3%
james	35	0.3%
david	32	0.3%
Other values (6549)	10675	90.0%

Most occurring characters

Value	Count	Frequency (%)
e	6873	9.7%
	6056	8.6%
a	5269	7.5%
n	4289	6.1%
r	4195	5.9%
o	4092	5.8%
i	4027	5.7%
l	3194	4.5%
s	3010	4.3%
t	2833	4.0%
Other values (91)	26789	37.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	51777	73.3%
Uppercase Letter	11997	17.0%
Space Separator	6056	8.6%
Other Punctuation	471	0.7%
Decimal Number	132	0.2%
Dash Punctuation	62	0.1%
Other Symbol	50	0.1%
Other Number	27	< 0.1%
Format	21	< 0.1%
Currency Symbol	10	< 0.1%
Other values (7)	24	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
T	1161	9.7%
B	1015	8.5%
S	996	8.3%
C	901	7.5%
M	900	7.5%
J	672	5.6%
R	612	5.1%
D	611	5.1%
L	579	4.8%
A	567	4.7%
Other values (17)	3983	33.2%

Lowercase Letter

Value	Count	Frequency (%)
e	6873	13.3%
a	5269	10.2%
n	4289	8.3%
r	4195	8.1%
o	4092	7.9%
i	4027	7.8%
l	3194	6.2%
s	3010	5.8%
t	2833	5.5%
h	2295	4.4%
Other values (16)	11700	22.6%

Other Punctuation

Value	Count	Frequency (%)
.	153	32.5%
&	134	28.5%
'	67	14.2%
"	38	8.1%
¡	19	4.0%
,	19	4.0%
!	16	3.4%
/	6	1.3%
¶	6	1.3%
*	5	1.1%
Other values (5)	8	1.7%

Decimal Number

Value	Count	Frequency (%)
0	22	16.7%
1	21	15.9%
2	19	14.4%
5	15	11.4%
3	13	9.8%
4	12	9.1%
7	10	7.6%
9	8	6.1%
8	6	4.5%
6	6	4.5%

Currency Symbol

Value	Count	Frequency (%)
£	5	50.0%
¢	2	20.0%
¤	2	20.0%
$	1	10.0%

Modifier Symbol

Value	Count	Frequency (%)
¸	3	37.5%
´	2	25.0%
¯	2	25.0%
˜	1	12.5%

Dash Punctuation

Value	Count	Frequency (%)
-	61	98.4%
–	1	1.6%

Other Number

Value	Count	Frequency (%)
³	23	85.2%
¼	4	14.8%

Math Symbol

Value	Count	Frequency (%)
±	4	80.0%
+	1	20.0%

Initial Punctuation

Value	Count	Frequency (%)
«	2	66.7%
“	1	33.3%

Space Separator

Value	Count	Frequency (%)
	6056	100.0%

Other Symbol

Value	Count	Frequency (%)
©	50	100.0%

Format

Value	Count	Frequency (%)
	21	100.0%

Other Letter

Value	Count	Frequency (%)
º	3	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	2	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	2	100.0%

Control

Value	Count	Frequency (%)
	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	63777	90.3%
Common	6850	9.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	6873	10.8%
a	5269	8.3%
n	4289	6.7%
r	4195	6.6%
o	4092	6.4%
i	4027	6.3%
l	3194	5.0%
s	3010	4.7%
t	2833	4.4%
h	2295	3.6%
Other values (44)	23700	37.2%

Common

Value	Count	Frequency (%)
	6056	88.4%
.	153	2.2%
&	134	2.0%
'	67	1.0%
-	61	0.9%
©	50	0.7%
"	38	0.6%
³	23	0.3%
0	22	0.3%
	21	0.3%
Other values (37)	225	3.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	70315	99.6%
None	307	0.4%
Punctuation	4	< 0.1%
Modifier Letters	1	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	6873	9.8%
	6056	8.6%
a	5269	7.5%
n	4289	6.1%
r	4195	6.0%
o	4092	5.8%
i	4027	5.7%
l	3194	4.5%
s	3010	4.3%
t	2833	4.0%
Other values (68)	26477	37.7%

None

Value	Count	Frequency (%)
Ã	156	50.8%
©	50	16.3%
³	23	7.5%
	21	6.8%
¡	19	6.2%
¶	6	2.0%
£	5	1.6%
±	4	1.3%
¼	4	1.3%
¸	3	1.0%
Other values (9)	16	5.2%

Punctuation

Value	Count	Frequency (%)
‰	2	50.0%
“	1	25.0%
–	1	25.0%

Modifier Letters

Value	Count	Frequency (%)
˜	1	100.0%

artist_id
Real number (ℝ)

UNIQUE

Distinct	5810
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	583166.45

Minimum	74
Maximum	3670556
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	90.8 KiB

Quantile statistics

Minimum	74
5-th percentile	31727.6
Q1	169016.75
median	423181
Q3	782355.5
95-th percentile	2126346.1
Maximum	3670556
Range	3670482
Interquartile range (IQR)	613338.75

Descriptive statistics

Standard deviation	647726.69
Coefficient of variation (CV)	1.1107064
Kurtosis	7.6930145
Mean	583166.45
Median Absolute Deviation (MAD)	300406.5
Skewness	2.6155375
Sum	3.3881971 × 10⁹
Variance	4.1954987 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
792507	1	< 0.1%
504169	1	< 0.1%
476744	1	< 0.1%
392925	1	< 0.1%
391519	1	< 0.1%
385766	1	< 0.1%
347639	1	< 0.1%
329313	1	< 0.1%
320470	1	< 0.1%
320442	1	< 0.1%
Other values (5800)	5800	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
74	1	< 0.1%
335	1	< 0.1%
441	1	< 0.1%
589	1	< 0.1%
1097	1	< 0.1%
1098	1	< 0.1%
1113	1	< 0.1%
1163	1	< 0.1%
1190	1	< 0.1%
1266	1	< 0.1%

Value	Count	Frequency (%)
3670556	1	< 0.1%
3661738	1	< 0.1%
3659356	1	< 0.1%
3639618	1	< 0.1%
3637248	1	< 0.1%
3632715	1	< 0.1%
3606027	1	< 0.1%
3567510	1	< 0.1%
3559122	1	< 0.1%
3539434	1	< 0.1%

danceability
Real number (ℝ)

HIGH CORRELATION

Distinct	4160
Distinct (%)	71.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.54530902

Minimum	0.0804
Maximum	0.962
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	90.8 KiB

Quantile statistics

Minimum	0.0804
5-th percentile	0.31281667
Q1	0.46033333
median	0.55005556
Q3	0.63658971
95-th percentile	0.76096538
Maximum	0.962
Range	0.8816
Interquartile range (IQR)	0.17625637

Descriptive statistics

Standard deviation	0.13523653
Coefficient of variation (CV)	0.24799981
Kurtosis	0.076167163
Mean	0.54530902
Median Absolute Deviation (MAD)	0.088055555
Skewness	-0.22992356
Sum	3168.2454
Variance	0.01828892
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.478	11	0.2%
0.562	10	0.2%
0.582	10	0.2%
0.484	10	0.2%
0.617	10	0.2%
0.628	9	0.2%
0.587	9	0.2%
0.458	9	0.2%
0.475	9	0.2%
0.621	8	0.1%
Other values (4150)	5715	98.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0804	1	< 0.1%
0.0811	1	< 0.1%
0.084	2	< 0.1%
0.0866	1	< 0.1%
0.0912	1	< 0.1%
0.096575	1	< 0.1%
0.105	1	< 0.1%
0.109	1	< 0.1%
0.1106	1	< 0.1%
0.114	1	< 0.1%

Value	Count	Frequency (%)
0.962	1	< 0.1%
0.928	1	< 0.1%
0.912	1	< 0.1%
0.908	1	< 0.1%
0.9075	1	< 0.1%
0.906	1	< 0.1%
0.903	1	< 0.1%
0.901	1	< 0.1%
0.898190476	1	< 0.1%
0.896	1	< 0.1%

energy
Real number (ℝ)

HIGH CORRELATION

Distinct	4484
Distinct (%)	77.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.58545841

Minimum	0.00198
Maximum	0.9995
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	90.8 KiB

Quantile statistics

Minimum	0.00198
5-th percentile	0.20766794
Q1	0.43
median	0.59848344
Q3	0.75131262
95-th percentile	0.9227
Maximum	0.9995
Range	0.99752
Interquartile range (IQR)	0.32131262

Descriptive statistics

Standard deviation	0.21623139
Coefficient of variation (CV)	0.3693369
Kurtosis	-0.5999758
Mean	0.58545841
Median Absolute Deviation (MAD)	0.15981677
Skewness	-0.26580355
Sum	3401.5133
Variance	0.046756016
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.43	10	0.2%
0.933	10	0.2%
0.587	9	0.2%
0.725	9	0.2%
0.872	8	0.1%
0.647	8	0.1%
0.63	7	0.1%
0.591	7	0.1%
0.658	7	0.1%
0.52	7	0.1%
Other values (4474)	5728	98.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.00198	1	< 0.1%
0.00249	2	< 0.1%
0.00459	1	< 0.1%
0.005	1	< 0.1%
0.00835	2	< 0.1%
0.01305	1	< 0.1%
0.0144	1	< 0.1%
0.0156	1	< 0.1%
0.0175	1	< 0.1%
0.01835	1	< 0.1%

Value	Count	Frequency (%)
0.9995	1	< 0.1%
0.999	1	< 0.1%
0.998	1	< 0.1%
0.994666667	1	< 0.1%
0.9935	1	< 0.1%
0.9925	1	< 0.1%
0.992	2	< 0.1%
0.991	3	0.1%
0.99	1	< 0.1%
0.989	2	< 0.1%

valence
Real number (ℝ)

HIGH CORRELATION

Distinct	4480
Distinct (%)	77.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.54500934

Minimum	0.02785
Maximum	0.98
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	90.8 KiB

Quantile statistics

Minimum	0.02785
5-th percentile	0.19545
Q1	0.40924507
median	0.55390685
Q3	0.68898437
95-th percentile	0.871275
Maximum	0.98
Range	0.95215
Interquartile range (IQR)	0.2797393

Descriptive statistics

Standard deviation	0.20040944
Coefficient of variation (CV)	0.36771743
Kurtosis	-0.42190045
Mean	0.54500934
Median Absolute Deviation (MAD)	0.13988958
Skewness	-0.18706766
Sum	3166.5043
Variance	0.040163942
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.649	11	0.2%
0.471	8	0.1%
0.679	8	0.1%
0.667	8	0.1%
0.96	7	0.1%
0.601	7	0.1%
0.961	7	0.1%
0.488	7	0.1%
0.289	7	0.1%
0.64	7	0.1%
Other values (4470)	5733	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.02785	1	< 0.1%
0.0279	1	< 0.1%
0.03055	1	< 0.1%
0.032675	1	< 0.1%
0.0328	1	< 0.1%
0.03312	1	< 0.1%
0.03505	1	< 0.1%
0.0352	1	< 0.1%
0.03585	1	< 0.1%
0.0364	1	< 0.1%

Value	Count	Frequency (%)
0.98	1	< 0.1%
0.979	2	< 0.1%
0.978	1	< 0.1%
0.976	1	< 0.1%
0.972	2	< 0.1%
0.971	1	< 0.1%
0.97	2	< 0.1%
0.96975	1	< 0.1%
0.969	2	< 0.1%
0.968	3	0.1%

tempo
Real number (ℝ)

Distinct	5769
Distinct (%)	99.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	120.36413

Minimum	30.946
Maximum	206.68
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	90.8 KiB

Quantile statistics

Minimum	30.946
5-th percentile	90.508129
Q1	109.44504
median	119.32445
Q3	129.87355
95-th percentile	154.30827
Maximum	206.68
Range	175.734
Interquartile range (IQR)	20.428506

Descriptive statistics

Standard deviation	19.193444
Coefficient of variation (CV)	0.15946149
Kurtosis	1.7924309
Mean	120.36413
Median Absolute Deviation (MAD)	10.210361
Skewness	0.57122067
Sum	699315.61
Variance	368.38831
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
193.041	3	0.1%
141.227	3	0.1%
135.903	2	< 0.1%
115.869	2	< 0.1%
113.325	2	< 0.1%
174.311	2	< 0.1%
83.444	2	< 0.1%
117.126	2	< 0.1%
104.153	2	< 0.1%
68.434	2	< 0.1%
Other values (5759)	5788	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
30.946	1	< 0.1%
55.807	1	< 0.1%
56.45466667	1	< 0.1%
58.66	1	< 0.1%
59.592	1	< 0.1%
62.825	1	< 0.1%
64.979	1	< 0.1%
66.668	1	< 0.1%
67.117	2	< 0.1%
67.469	1	< 0.1%

Value	Count	Frequency (%)
206.68	1	< 0.1%
205.703	1	< 0.1%
203.179	1	< 0.1%
202.409	1	< 0.1%
202.318	1	< 0.1%
201.885	1	< 0.1%
201.712	1	< 0.1%
200.033	1	< 0.1%
199.693	1	< 0.1%
199.04	1	< 0.1%

loudness
Real number (ℝ)

HIGH CORRELATION

Distinct	5653
Distinct (%)	97.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-9.9519694

Minimum	-40.147
Maximum	1.342
Zeros	0
Zeros (%)	0.0%
Negative	5809
Negative (%)	> 99.9%
Memory size	90.8 KiB

Quantile statistics

Minimum	-40.147
5-th percentile	-17.165432
Q1	-12.240722
median	-9.5258333
Q3	-6.862625
95-th percentile	-4.3534698
Maximum	1.342
Range	41.489
Interquartile range (IQR)	5.3780972

Descriptive statistics

Standard deviation	4.1803796
Coefficient of variation (CV)	-0.42005551
Kurtosis	2.9504352
Mean	-9.9519694
Median Absolute Deviation (MAD)	2.6919333
Skewness	-1.1068991
Sum	-57820.942
Variance	17.475573
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-10.146	3	0.1%
-5.541	3	0.1%
-4.0355	3	0.1%
-6.944	3	0.1%
-9.344	3	0.1%
-6.979	3	0.1%
-4.966	3	0.1%
-10.384	3	0.1%
-7.305	3	0.1%
-6.323	3	0.1%
Other values (5643)	5780	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-40.147	1	< 0.1%
-35.951	1	< 0.1%
-35.116	1	< 0.1%
-34.366	2	< 0.1%
-33.47625	1	< 0.1%
-33.475	2	< 0.1%
-32.667	1	< 0.1%
-32.652	1	< 0.1%
-32.347	1	< 0.1%
-30.84	1	< 0.1%

Value	Count	Frequency (%)
1.342	1	< 0.1%
-0.19	1	< 0.1%
-0.866	1	< 0.1%
-1.092	1	< 0.1%
-1.158	1	< 0.1%
-1.387	1	< 0.1%
-1.714	1	< 0.1%
-1.731	1	< 0.1%
-1.847	1	< 0.1%
-1.987	1	< 0.1%

mode
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	374.5 KiB

1	4769
0	1041

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5810
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	4769	82.1%
0	1041	17.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	4769	82.1%
0	1041	17.9%

Most occurring characters

Value	Count	Frequency (%)
1	4769	82.1%
0	1041	17.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5810	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	4769	82.1%
0	1041	17.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	5810	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	4769	82.1%
0	1041	17.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5810	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	4769	82.1%
0	1041	17.9%

key
Real number (ℝ)

ZEROS

Distinct	12
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.5194492

Minimum	0
Maximum	11
Zeros	663
Zeros (%)	11.4%
Negative	0
Negative (%)	0.0%
Memory size	90.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	6
Q3	9
95-th percentile	11
Maximum	11
Range	11
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	3.5149706
Coefficient of variation (CV)	0.63683358
Kurtosis	-1.2305514
Mean	5.5194492
Median Absolute Deviation (MAD)	3
Skewness	-0.1319333
Sum	32068
Variance	12.355018
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
7	925	15.9%
9	736	12.7%
0	663	11.4%
2	637	11.0%
5	528	9.1%
11	460	7.9%
1	398	6.9%
4	385	6.6%
10	359	6.2%
6	320	5.5%
Other values (2)	399	6.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	663	11.4%
1	398	6.9%
2	637	11.0%
3	129	2.2%
4	385	6.6%
5	528	9.1%
6	320	5.5%
7	925	15.9%
8	270	4.6%
9	736	12.7%

Value	Count	Frequency (%)
11	460	7.9%
10	359	6.2%
9	736	12.7%
8	270	4.6%
7	925	15.9%
6	320	5.5%
5	528	9.1%
4	385	6.6%
3	129	2.2%
2	637	11.0%

acousticness
Real number (ℝ)

HIGH CORRELATION

Distinct	5261
Distinct (%)	90.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.34386401

Minimum	1.01 × 10^-6
Maximum	0.996
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	90.8 KiB

Quantile statistics

Minimum	1.01 × 10^-6
5-th percentile	0.0017
Q1	0.081277142
median	0.26857404
Q3	0.578375
95-th percentile	0.88934375
Maximum	0.996
Range	0.99599899
Interquartile range (IQR)	0.49709786

Descriptive statistics

Standard deviation	0.29506106
Coefficient of variation (CV)	0.85807485
Kurtosis	-0.9115293
Mean	0.34386401
Median Absolute Deviation (MAD)	0.22050964
Skewness	0.58967187
Sum	1997.8499
Variance	0.087061031
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.273	5	0.1%
0.367	5	0.1%
0.815	5	0.1%
0.299	5	0.1%
0.988	5	0.1%
0.308	4	0.1%
0.612	4	0.1%
0.2	4	0.1%
0.59	4	0.1%
0.992	4	0.1%
Other values (5251)	5765	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.01 × 10^-6	1	< 0.1%
1.41 × 10^-6	1	< 0.1%
1.59 × 10^-6	1	< 0.1%
3.37 × 10^-6	1	< 0.1%
3.48 × 10^-6	1	< 0.1%
4.12 × 10^-6	1	< 0.1%
4.21 × 10^-6	1	< 0.1%
4.41 × 10^-6	1	< 0.1%
4.45 × 10^-6	1	< 0.1%
6.51 × 10^-6	1	< 0.1%

Value	Count	Frequency (%)
0.996	3	0.1%
0.9948125	1	< 0.1%
0.994666667	1	< 0.1%
0.993	2	< 0.1%
0.992	4	0.1%
0.991333333	1	< 0.1%
0.991	2	< 0.1%
0.990070423	1	< 0.1%
0.99	2	< 0.1%
0.9895	1	< 0.1%

instrumentalness
Real number (ℝ)

ZEROS

Distinct	4931
Distinct (%)	84.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.1323074

Minimum	0
Maximum	0.973
Zeros	479
Zeros (%)	8.2%
Negative	0
Negative (%)	0.0%
Memory size	90.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	9.63 × 10^-5
median	0.0086786085
Q3	0.14299193
95-th percentile	0.75233
Maximum	0.973
Range	0.973
Interquartile range (IQR)	0.14289563

Descriptive statistics

Standard deviation	0.23373132
Coefficient of variation (CV)	1.7665779
Kurtosis	2.9483462
Mean	0.1323074
Median Absolute Deviation (MAD)	0.0086786085
Skewness	1.9970166
Sum	768.70597
Variance	0.054630329
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	479	8.2%
1.18 × 10^-5	7	0.1%
1.02 × 10^-5	5	0.1%
2.54 × 10^-5	5	0.1%
1.84 × 10^-5	4	0.1%
2.51 × 10^-5	4	0.1%
1.16 × 10^-5	4	0.1%
1.3 × 10^-5	4	0.1%
0.00225	4	0.1%
3.43 × 10^-5	4	0.1%
Other values (4921)	5290	91.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	479	8.2%
6.65 × 10^-8	1	< 0.1%
7.23 × 10^-8	1	< 0.1%
8.21 × 10^-8	1	< 0.1%
8.83 × 10^-8	1	< 0.1%
1.09 × 10^-7	1	< 0.1%
1.28 × 10^-7	1	< 0.1%
1.46 × 10^-7	1	< 0.1%
1.54 × 10^-7	1	< 0.1%
1.69 × 10^-7	1	< 0.1%

Value	Count	Frequency (%)
0.973	1	< 0.1%
0.963	1	< 0.1%
0.962	1	< 0.1%
0.957	1	< 0.1%
0.9525	1	< 0.1%
0.951	3	0.1%
0.949	1	< 0.1%
0.9436875	1	< 0.1%
0.943	2	< 0.1%
0.942	1	< 0.1%

liveness
Real number (ℝ)

Distinct	4752
Distinct (%)	81.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.19564545

Minimum	0.0116
Maximum	0.973
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	90.8 KiB

Quantile statistics

Minimum	0.0116
5-th percentile	0.079
Q1	0.12481791
median	0.16986072
Q3	0.22936382
95-th percentile	0.39207944
Maximum	0.973
Range	0.9614
Interquartile range (IQR)	0.10454591

Descriptive statistics

Standard deviation	0.1162328
Coefficient of variation (CV)	0.59409918
Kurtosis	10.361255
Mean	0.19564545
Median Absolute Deviation (MAD)	0.049860717
Skewness	2.6299371
Sum	1136.7001
Variance	0.013510065
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.102	16	0.3%
0.103	16	0.3%
0.109	15	0.3%
0.108	14	0.2%
0.106	13	0.2%
0.115	12	0.2%
0.122	12	0.2%
0.111	12	0.2%
0.13	11	0.2%
0.125	11	0.2%
Other values (4742)	5678	97.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0116	1	< 0.1%
0.0222	1	< 0.1%
0.0224	1	< 0.1%
0.025	1	< 0.1%
0.0258	1	< 0.1%
0.0269	1	< 0.1%
0.0278	1	< 0.1%
0.0302	1	< 0.1%
0.03045	1	< 0.1%
0.0311	2	< 0.1%

Value	Count	Frequency (%)
0.973	1	< 0.1%
0.972	1	< 0.1%
0.965	1	< 0.1%
0.964	1	< 0.1%
0.962	1	< 0.1%
0.96	2	< 0.1%
0.951	1	< 0.1%
0.95	1	< 0.1%
0.932	2	< 0.1%
0.922	1	< 0.1%

speechiness
Real number (ℝ)

Distinct	4363
Distinct (%)	75.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.069731166

Minimum	0.0232
Maximum	0.958
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	90.8 KiB

Quantile statistics

Minimum	0.0232
5-th percentile	0.030575
Q1	0.038138988
median	0.048655
Q3	0.072845833
95-th percentile	0.171955
Maximum	0.958
Range	0.9348
Interquartile range (IQR)	0.034706845

Descriptive statistics

Standard deviation	0.075563982
Coefficient of variation (CV)	1.0836472
Kurtosis	66.115913
Mean	0.069731166
Median Absolute Deviation (MAD)	0.013255
Skewness	6.9385041
Sum	405.13808
Variance	0.0057099154
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0367	12	0.2%
0.0372	11	0.2%
0.0356	11	0.2%
0.0328	11	0.2%
0.0314	10	0.2%
0.0352	9	0.2%
0.0384	9	0.2%
0.0331	9	0.2%
0.0312	9	0.2%
0.0353	9	0.2%
Other values (4353)	5710	98.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0232	1	< 0.1%
0.0236	1	< 0.1%
0.024	1	< 0.1%
0.0243	1	< 0.1%
0.0245	2	< 0.1%
0.0246	2	< 0.1%
0.0252	2	< 0.1%
0.0253	1	< 0.1%
0.0256	3	0.1%
0.0257	1	< 0.1%

Value	Count	Frequency (%)
0.958	1	< 0.1%
0.95	1	< 0.1%
0.948	1	< 0.1%
0.945	2	< 0.1%
0.9416	1	< 0.1%
0.9396	1	< 0.1%
0.936666667	1	< 0.1%
0.924	1	< 0.1%
0.92	1	< 0.1%
0.913	1	< 0.1%

duration_ms
Real number (ℝ)

Distinct	5745
Distinct (%)	98.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	246401.34

Minimum	45707
Maximum	1640000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	90.8 KiB

Quantile statistics

Minimum	45707
5-th percentile	150830.44
Q1	197228.25
median	234998.92
Q3	276208.94
95-th percentile	385557.2
Maximum	1640000
Range	1594293
Interquartile range (IQR)	78980.689

Descriptive statistics

Standard deviation	83859.416
Coefficient of variation (CV)	0.34033669
Kurtosis	36.8789
Mean	246401.34
Median Absolute Deviation (MAD)	39080.171
Skewness	3.7307215
Sum	1.4315918 × 10⁹
Variance	7.0324017 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
627330	3	0.1%
179800	3	0.1%
465713.5	3	0.1%
170880	2	< 0.1%
389893	2	< 0.1%
201067	2	< 0.1%
234107	2	< 0.1%
319733	2	< 0.1%
202133	2	< 0.1%
163973	2	< 0.1%
Other values (5735)	5787	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
45707	1	< 0.1%
66333	1	< 0.1%
70587.61538	1	< 0.1%
71400	1	< 0.1%
74033.5	1	< 0.1%
74320	1	< 0.1%
79333	1	< 0.1%
85206.5	1	< 0.1%
87896.75	1	< 0.1%
88822	1	< 0.1%

Value	Count	Frequency (%)
1640000	1	< 0.1%
1415707	1	< 0.1%
1260000	1	< 0.1%
1204090	1	< 0.1%
1187042	1	< 0.1%
1171360	1	< 0.1%
1087660	1	< 0.1%
902051.8788	1	< 0.1%
860706.8	1	< 0.1%
853670	1	< 0.1%

popularity
Real number (ℝ)

HIGH CORRELATION

Distinct	2652
Distinct (%)	45.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	39.587142

Minimum	0
Maximum	81
Zeros	33
Zeros (%)	0.6%
Negative	0
Negative (%)	0.0%
Memory size	90.8 KiB

Quantile statistics

Minimum	0
5-th percentile	14.26
Q1	32.333333
median	40.285714
Q3	48.5
95-th percentile	59.5
Maximum	81
Range	81
Interquartile range (IQR)	16.166667

Descriptive statistics

Standard deviation	13.23839
Coefficient of variation (CV)	0.33441135
Kurtosis	0.5251484
Mean	39.587142
Median Absolute Deviation (MAD)	8.047619
Skewness	-0.50870135
Sum	230001.3
Variance	175.25497
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40	81	1.4%
42	81	1.4%
43	71	1.2%
39	70	1.2%
46	67	1.2%
37	66	1.1%
44	66	1.1%
41	63	1.1%
38	62	1.1%
35	62	1.1%
Other values (2642)	5121	88.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	33	0.6%
0.2	1	< 0.1%
0.301724138	1	< 0.1%
0.333333333	1	< 0.1%
0.384615385	1	< 0.1%
0.410958904	1	< 0.1%
0.538461538	1	< 0.1%
0.571428571	1	< 0.1%
0.6	1	< 0.1%
0.823529412	1	< 0.1%

Value	Count	Frequency (%)
81	1	< 0.1%
77.50704225	1	< 0.1%
77.03846154	1	< 0.1%
77	1	< 0.1%
76.83333333	1	< 0.1%
76	1	< 0.1%
74.8	1	< 0.1%
74	2	< 0.1%
73.5	2	< 0.1%
73.24193548	1	< 0.1%

count
Real number (ℝ)

Distinct	300
Distinct (%)	5.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.50241

Minimum	1
Maximum	1369
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	90.8 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	4
median	10
Q3	31
95-th percentile	137
Maximum	1369
Range	1368
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	77.300072
Coefficient of variation (CV)	2.3072989
Kurtosis	81.728731
Mean	33.50241
Median Absolute Deviation (MAD)	8
Skewness	7.4876933
Sum	194649
Variance	5975.3012
Monotonicity	Decreasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	1097	18.9%
4	581	10.0%
6	384	6.6%
8	274	4.7%
10	239	4.1%
12	200	3.4%
14	159	2.7%
18	148	2.5%
16	147	2.5%
1	138	2.4%
Other values (290)	2443	42.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	138	2.4%
2	1097	18.9%
3	78	1.3%
4	581	10.0%
5	76	1.3%
6	384	6.6%
7	67	1.2%
8	274	4.7%
9	44	0.8%
10	239	4.1%

Value	Count	Frequency (%)
1369	1	< 0.1%
1207	1	< 0.1%
1104	1	< 0.1%
1095	1	< 0.1%
1092	1	< 0.1%
1035	1	< 0.1%
994	1	< 0.1%
990	1	< 0.1%
938	1	< 0.1%
864	1	< 0.1%

Auto

Heatmap
Table

	artist_id	danceability	energy	valence	tempo	loudness	key	acousticness	instrumentalness	liveness	speechiness	duration_ms	popularity	count	mode
artist_id	1.000	0.025	0.059	-0.079	-0.002	0.132	-0.019	-0.070	-0.055	-0.019	0.038	-0.028	0.198	-0.028	0.050
danceability	0.025	1.000	0.007	0.564	-0.123	0.072	0.012	-0.026	-0.188	-0.184	0.088	-0.014	0.169	-0.041	0.147
energy	0.059	0.007	1.000	0.194	0.331	0.784	0.045	-0.793	-0.109	0.198	0.277	0.015	0.355	-0.107	0.055
valence	-0.079	0.564	0.194	1.000	0.093	0.073	0.009	-0.061	-0.156	-0.009	0.058	-0.219	-0.129	-0.019	0.067
tempo	-0.002	-0.123	0.331	0.093	1.000	0.251	0.015	-0.291	-0.044	0.066	0.101	-0.059	0.102	0.001	0.057
loudness	0.132	0.072	0.784	0.073	0.251	1.000	0.035	-0.615	-0.311	0.130	0.204	-0.070	0.521	-0.090	0.085
key	-0.019	0.012	0.045	0.009	0.015	0.035	1.000	-0.060	-0.017	-0.008	0.019	-0.007	0.032	-0.032	0.150
acousticness	-0.070	-0.026	-0.793	-0.061	-0.291	-0.615	-0.060	1.000	0.075	-0.083	-0.179	-0.121	-0.397	0.144	0.081
instrumentalness	-0.055	-0.188	-0.109	-0.156	-0.044	-0.311	-0.017	0.075	1.000	-0.019	-0.027	0.243	-0.237	0.200	0.090
liveness	-0.019	-0.184	0.198	-0.009	0.066	0.130	-0.008	-0.083	-0.019	1.000	0.178	-0.067	-0.080	0.213	0.092
speechiness	0.038	0.088	0.277	0.058	0.101	0.204	0.019	-0.179	-0.027	0.178	1.000	-0.034	0.025	0.081	0.072
duration_ms	-0.028	-0.014	0.015	-0.219	-0.059	-0.070	-0.007	-0.121	0.243	-0.067	-0.034	1.000	0.123	-0.011	0.124
popularity	0.198	0.169	0.355	-0.129	0.102	0.521	0.032	-0.397	-0.237	-0.080	0.025	0.123	1.000	-0.138	0.109
count	-0.028	-0.041	-0.107	-0.019	0.001	-0.090	-0.032	0.144	0.200	0.213	0.081	-0.011	-0.138	1.000	0.064
mode	0.050	0.147	0.055	0.067	0.057	0.085	0.150	0.081	0.090	0.092	0.072	0.124	0.109	0.064	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	artist_name	artist_id	danceability	energy	valence	tempo	loudness	mode	key	acousticness	instrumentalness	liveness	speechiness	duration_ms	popularity	count
0	Frank Sinatra	792507	0.384478	0.238017	0.364288	110.181698	-14.271141	1	5	0.735648	0.020855	0.232106	0.049614	189179.9255	26.004383	1369
1	Vladimir Horowitz	119107	0.343210	0.118844	0.225951	94.900679	-23.193418	1	1	0.990070	0.879508	0.183812	0.043360	266541.1251	3.592378	1207
2	Johnny Cash	816890	0.619803	0.449381	0.680662	115.037747	-11.593104	1	10	0.685637	0.022647	0.242243	0.098216	162279.2672	26.614130	1104
3	Billie Holiday	79016	0.572637	0.201368	0.498934	109.912172	-13.225966	1	5	0.908499	0.013064	0.217727	0.062432	185131.4530	15.621005	1095
4	Bob Dylan	66915	0.512598	0.477932	0.551934	126.160149	-11.184330	1	7	0.562567	0.034211	0.308978	0.064535	256713.4203	30.860806	1092
5	The Rolling Stones	894465	0.524446	0.719915	0.655332	123.764717	-7.830265	1	0	0.293788	0.176137	0.268443	0.051440	229705.9623	34.573913	1035
6	The Beach Boys	41874	0.502945	0.532131	0.633957	125.992036	-9.925742	1	9	0.398488	0.115363	0.191189	0.043971	148845.0946	27.957746	994
7	Elvis Presley	180228	0.495843	0.426308	0.621249	111.489453	-12.893730	1	0	0.741412	0.053623	0.247346	0.058278	156211.0354	33.391919	990
8	Wolfgang Amadeus Mozart	26350	0.353346	0.137869	0.330529	108.604340	-20.174257	1	7	0.961572	0.508881	0.188828	0.068485	329702.9243	8.936034	938
9	Miles Davis	423829	0.460221	0.308229	0.417860	113.550382	-14.526619	0	0	0.655711	0.205073	0.219762	0.054571	404023.4456	22.700231	864

	artist_name	artist_id	danceability	energy	valence	tempo	loudness	mode	key	acousticness	instrumentalness	liveness	speechiness	duration_ms	popularity	count
5844	Jonn Hart	3043787	0.686	0.541	0.237	96.965	-6.643	0	4	0.097100	0.000000	0.4230	0.0356	189613.0	49.0	1
5845	Hiatus Kaiyote	3045620	0.552	0.531	0.324	91.573	-6.767	1	8	0.656000	0.000052	0.1100	0.1250	275320.0	57.0	1
5846	Gawvi	3099573	0.683	0.630	0.452	159.927	-5.146	1	1	0.320000	0.000000	0.2220	0.0587	203325.0	60.0	1
5847	Adrian Marcel	3120458	0.849	0.534	0.599	102.014	-6.365	1	4	0.047200	0.000000	0.2500	0.0699	237653.0	59.0	1
5848	Karen Harding	3308665	0.701	0.667	0.675	119.975	-6.177	1	7	0.012100	0.000007	0.1480	0.0361	213135.0	67.0	1
5849	Natalie La Rose	3359519	0.830	0.520	0.735	104.990	-8.714	1	0	0.000792	0.000013	0.0656	0.0376	189907.0	64.0	1
5850	Sarah Ross	3381566	0.721	0.944	0.626	85.002	-5.982	1	8	0.013000	0.000000	0.3200	0.1590	262760.0	52.0	1
5851	Rotimi	3410250	0.637	0.501	0.431	103.993	-6.148	0	0	0.229000	0.000059	0.0990	0.1870	185461.0	71.0	1
5852	Jillian Jacqueline	3455945	0.547	0.672	0.283	155.791	-5.023	1	11	0.304000	0.000000	0.0996	0.0496	213133.0	58.0	1
5853	Jaira Burns	3639618	0.566	0.769	0.385	170.036	-4.342	1	7	0.018300	0.000000	0.1080	0.0872	191100.0	74.0	1

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Decimal Number

Currency Symbol

Modifier Symbol

Dash Punctuation

Other Number

Math Symbol

Initial Punctuation

Space Separator

Other Symbol

Format

Other Letter

Close Punctuation

Open Punctuation

Control

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Punctuation

Modifier Letters

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample